Page 1

LILAC Document Help

Documents > Stock Posting

This document is used to adjust Stock Account levels.
Using the Head of the document, select a Ledger and Main (Account) for the balancing entry to the Stock Value.
Using the Body of the document, the Product Code(s) are selected in the Main field.

An example below shows "writing off" damaged or missing stock to an expense account.

Stock quantity is reduced by 2, by using -2 in the Items column.
The Value, -$20 Credits (reduces) the Stock Account, and a balancing entry of $20 debits the TRADING : WRITE OFF.
TRADING : WRITE OFF has been established in the General Ledger as an INDIRECT, EXPENSE account, Non Taxable.

Enter a Day key, ie 13 for the thirteenth day of the month. Any two character alpha-numeric values are permitted, ie the intials of the User, AZ are permitted.

*The Day key forms part of the Batch Key.
Reports > General Ledger > Audit Trail (Month To Date + Batch Parameter), or, Reports > General Ledger > Batch Totals, will list the result of Stock Posting according to the Batch Key SPO0013 (SPO indicated the Stock Posting document).

Select a Ledger and Main (Account) to receive the balancing value.

$20 will be debited to the expense account TRADING : WRITE OFF

Stock is reduced, -2 Items at a total Value of -$20, a credit to the Stock Account.
Main (Product Code).
A Ref (Reference) can be manually entered or will populate from the head of the document.
Standard Cost is populated from the Stock Account.

'Apply' will post the Debits and Credits, to the Stock Account and to the Account specified in the Head of the document.

Stock > Stock Posting

Page 2
Stock > Stock Posting

Below the 'Apply' button has been clicked. -20.00 is Posted.

Stock > Stock Posting

Page 3
Document Title

The Stock Account is reduced. The intention is to reduce this Product Code to a quantity of 8.
The Product Code is to be written off at the Standard Cost, 2 x $10.

Stock Posting

Page 4
Document Title

Purpose: This document may be used to adjust stock, for example write off damaged stock.
This document may also be used during entity setup, ie the intial posting of stock to a Stock Account.

Prerequisites: The Product Code must be established in the database via the Stock > Account document. The account for the other side of the transaction must also be established in the database.

Period: The current account period is displayed here. This is established when the user signs in.
Prefix: This field is set to be "SPO", to establish it as a Stock Posting. SPO form part of the Batch key.
Computer: This field is set to the instance number LILAC.
Day: Type a number relevant to the posting eg: the date postings were processed on the 8th.
Value: The Total amount to be posted.
Ledger: Type the first letter of the ledger this posting refers to. Strike the Tab Key. This action will display a search window. To select the ledger, (if it is correct) strike the Tab key. (which then moves you across to the next field).
Main: Type in the general ledger account number or name that relates to this posting. (can use first letter and Tab as above).
Date: Select the date of transaction.
Ref: Type a reference for this transaction.
Description: Type in a brief description on the nature of the posting eg: Establish Stock

Items: Type in the number of items to post.
Main: Type in the stock account key (or click the right mouse button) and select the key from the list.
Bin: Type in the physical location of the stock, or leave blank if you are not using bin locations.
Description: Description of this product.
Standard Cost: This field is automatically retrieved from the Product Master Records. However, you can overtype the default amount if you wish. The Standard Cost field always excludes GST, and should never be changed unless the cost of the product substantially and permanently changes. Changing this field frequently will cause your purchase variations to be unreliable.
Value: Displays the financial value of this entry. This is equivalent to the Quantity * Standard Cost.
Posted: Displays the value already processed.

Transaction Processing Button Description:
Apply: Clicking the Apply button will post the entries to the accounts specified.